Dr. Murali Shanker, A401 BSA |
Dr. J. Randall Brown |
E-mail: mshanker@kent.edu |
E-mail: rbrown@bsa3.kent.edu |
Phone: (330) 672-1165 |
Phone: (330) 672-1150 |
IM: AOL mshanker1; Yahoo mshanker1 |
|
Office Hours: 12:30-1:30; 5:00-5:30 T and TH, and by appointment |
Course Web Site : https://class.kent.edu
|
Section 001 : 1:45-3:00 PM T, TH, 206 BSA (Final Exam: 11 December
2002; 12:45 - 2:00 PM)
Section 002 : 5:30-6:45 PM T, TH, 206 BSA (Final Exam: 10 December
2002; 5:45 - 7:00 PM)
Last day to drop a course: 2 November 2002
Prerequisites: M&IS 24053, Introduction to Computer Applications.
Students attending the course who do not have the proper prerequisite risk being
deregistered from the class.
Enrollment: It is the student’s responsibility to ensure proper enrollment in classes. You are advised to review your official class schedule during the first two weeks of the semester to ensure proper enrollment. Should you determine an error in your class schedule, you have until 7 September 2002 to correct it with your advising office. If registration errors are not corrected by this date and you continue to attend and participate in classes for which you are not officially enrolled, you are advised now that you will not receive a grade at the conclusion of the semester.
Students With Disabilities: In accordance with University policy, if you have a documented disability and require accommodations to obtain equal access in this course, please contact the instructor at the beginning of the semester or when given an assignment for which an accommodation is required. Students with disabilities must verify their eligibility through the Office of Student Disability Services (SDS) located in room 181 of the Michael Schwartz Student Services Center (Voice/TTD: 672-3391).
Academic Honesty: Cheating means to misrepresent the source, nature, or other conditions of your academic work (e.g., tests, papers, projects, assignments) so as to get undeserved credit. The use of intellectual property of others without giving them appropriate credit is a serious academic offense. It is the University’s policy that cheating or plagiarism result in receiving a failing grade for the work or course. Repeat offenses result in dismissal from the University.
There will be three projects to be turned in, three in-class group projects, four online quizzes, and three exams in this course. The breakdown is as follows:
Exams: All exams are closed book, multiple choice, and machine graded. Don’t forget to bring a pencil and eraser to the test. Exam 2 and the final exam are comprehensive.
Homework: Homework will not be collected as the solutions are in the Class Notes and the book. Each student should expect to spend approximately 6 hours per week working on the course outside of class.
Projects: Each project is due at the beginning of class on the day listed in the table on the next page. As with exams, a project can be handed in early but cannot be handed in late. HINT: Projects 2 and 3 are especially time consuming so start them early.
Group Tasks: Each of the three group tasks will take two class periods for a total of eight class periods. You will be arbitrarily assigned to a group to simulate what happens in business. Your assigned group is listed on the WebCT site. All group tasks will be done entirely in class so attendance is essential. Attendance will be taken and you will receive 10 points for each of the six class periods you attend and 5 points if you attend both class periods for a task (like exams, there are no excused absences). Note that the objective is for you to participate in the group discussions and presentations. At the instructor’s discretion, anyone not making an effort to participate will not receive the 10 points for the class period even though they were physically present. In addition, students who are more than one minute late for their group sessions will not receive the 10 points.
Grading Scale: A: 810—914 points, B: 720—809 points, C: 630—719 points, D: 540—629 points, and F: 0—539 points.
None of the quizzes or exams can be made up. You will receive a score of zero (0) for any missed quizzes/exams. An exam may be taken early (see instructor), but cannot be taken late. There are no exceptions (remember, the lowest grade exam is automatically dropped). Exam, quiz, and project dates are listed in the tables below.
Required Text: Paul Cassel and Pamela Palmer. SAMS Teach Yourself Access 2000 in 21 Days, Sams Publishing, 1999. ISBN: 0-672-31292-1
Required Class Notes: Systems Analysis I, Notes, Fall 2002. May be purchased for $30.00 from Dr. Shanker in his office (Room A401 BSA) with cash or a check payable to “Cash”. Any class notes from previous semesters do not contain the current changes and additions so you need the current semester’s class notes.
Computer Labs: All computers in the BSA computer lab have Access 2000 and a CD-ROM. In addition, the computer labs in Bowman. the Library, the Student Center, and Music and Speech also have Access 2000. The BSA computer lab is open Monday through Thursday from 9AM to 11PM, Friday from 9AM to 9PM, Saturday from 9AM to 5PM, and Sunday from 12 noon to 6PM. Finally, CD’s to install Office XP on your computer can be purchased from the KSU Bookstore for $20.00.
This course use a system called WebCT to organize and present online content. WebCT allows the instructor to provide a comprehensive solution to presenting online content, and student management. Thus, in addition to taking online examinations, and reading material from online content, the student is able to track their progress, interact with fellow students through chat and e-mail, and even make online presentations. The following pages give a brief introduction to WebCT for your course.
Before you can access this course, you must create a myWebCT account. This account will be the starting point for all courses using the WebCT system.
Everyone needs a User Name and password to log on to WebCT. They are the same as the ones used for your KSU email account. The User Name and password are case-sensitive in WebCT. That means it make a difference whether you use capital letters or not.
If you already use your KSU email account and know your password you're about ready to go: read the Password Management (http://webcthelp.kent.edu/v3/student/password.html) section of this guide and then go to class.kent.edu to log in (assuming your professor has already given you access to the course). If you don't know about your KSU email account, read on.
User Name: The first step is to find out your User Name. Go to the Username Request Form (https://secure.kent.edu/userid/), enter your Social Security Number, and your user ID will be displayed. You will use it both for WebCT and for your KSU email account. (If you don't plan on using your KSU email account you should set up automatic forwarding (http://www.personal.kent.edu/forward.html) to another email account.
The following tables contains the class schedule. Note that online quizzes begin on the Monday of the week they are assigned, and are available until Sunday 11:50 p.m. (ET) of that week. For example, Quiz 1 can be taken from Monday, 2 September 2002, until Sunday, 8 September 2002, 11:50 p.m.
Date | Teach yourself Access 2000 | Class Sections | Tutorials, Detail Problems, Projects |
Aug 27 |
Day 1 |
Introduction |
Tutorial: Windows Explorer |
Aug 29 |
Day 2 |
Database, Relational Databases 1-6. |
Database Detail Problem |
Sept 3 |
Day 3 |
Relational Databases 7-17 |
Relational Databases Detail Problem |
Sept 5 |
Day 4 |
Database Design and Normalization 23-50 |
|
Sept 10 |
Day 5 |
Course Number Change Problem |
Database Design and Normalization Detail Problem |
Sept 12 |
Day 6 |
House Analogy |
Northwind Database Detail Problem |
Sept 17 |
Days 7, 8 |
System Design Methodology |
|
Sept 19 |
Day 9 |
Data Modeling, Group Tasks Introduction |
Relationships Detail Problem Fields Detail Problem |
Sept 24 |
Days 10 and 11 |
TASK 1: Group Meetings |
Queries Detail Problem |
Sept 26 |
Day 12 |
TASK 1: Group Presentations |
|
Oct 1 |
Day 13 |
Process Modeling |
|
Oct 3 |
Day 14 |
Process Analysis and Design |
Project 1 Due: Query & Forms |
Oct 8 |
Day 15 |
Change ADMSys.mdb To M&ISys.mdb |
|
Oct 10 |
Day 15 |
Design M&IS System |
|
Oct 15 |
Exam 1 (in class) All topics to date |
Exam 1 |
|
Oct 17 |
Day 16 |
Business System History 1-46 |
|
Oct 22 |
Day 16 |
Business System History 47-75 |
|
Oct 24 |
Day 17 |
Instructor & Courses Project Discussion & Hints |
|
Oct 29 |
Day 17 |
TASK 2: Group Meetings |
|
Oct 31 |
Day 18 |
TASK 2: Group Presentations |
Project 2 Due: Instructor & Courses |
Nov 5 |
Day 19 |
Maintaining Parks 1-60 |
Dots and Bangs Detail Problem |
Nov 7 |
Day 19 |
Maintaining Parks 61-97 |
|
Nov 12 |
Day 19 |
TASK 3: Group Meetings |
Programming Detail Problem |
Nov 14 |
Day 20 |
TASK 3: Group Presentations |
|
Nov 19 |
Day 20 |
Courses & Days Project Discussion & Hints |
|
Nov 21 |
Day 21 |
||
Nov 26 |
Project 3 Due: Courses & Days |
||
Nov 28 |
Thanksgiving |
||
Dec 3 |
Day 21 |
||
DEC 5 | Exam 2 (in class) All topics | Exam 2 | |
Final Exam |
Section 001: 11 December 2002; 12:45 - 2:00 PM |
Quiz |
Topics |
Start Date |
End Date (11:50 PM ET) |
1 |
Access 2000 Days 1-3, Introduction, Database, Relational Databases |
September 9 |
September 15 |
2 |
Access 2000 Days 4-6,
Database Design and Normalization, |
September 16 |
September 22 |
3 |
Access 2000 Days 7-11,
Models and Modeling, |
September 30 |
October 6 |
4 |
Access 2000 Days 16-19,
Business System History, |
November 18 |
November 24 |